package com.example.demo.pojo;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class MemberExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MemberExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(BigDecimal value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(BigDecimal value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(BigDecimal value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(BigDecimal value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<BigDecimal> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<BigDecimal> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andGytypeIsNull() {
            addCriterion("GYTYPE is null");
            return (Criteria) this;
        }

        public Criteria andGytypeIsNotNull() {
            addCriterion("GYTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andGytypeEqualTo(String value) {
            addCriterion("GYTYPE =", value, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeNotEqualTo(String value) {
            addCriterion("GYTYPE <>", value, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeGreaterThan(String value) {
            addCriterion("GYTYPE >", value, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeGreaterThanOrEqualTo(String value) {
            addCriterion("GYTYPE >=", value, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeLessThan(String value) {
            addCriterion("GYTYPE <", value, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeLessThanOrEqualTo(String value) {
            addCriterion("GYTYPE <=", value, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeLike(String value) {
            addCriterion("GYTYPE like", value, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeNotLike(String value) {
            addCriterion("GYTYPE not like", value, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeIn(List<String> values) {
            addCriterion("GYTYPE in", values, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeNotIn(List<String> values) {
            addCriterion("GYTYPE not in", values, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeBetween(String value1, String value2) {
            addCriterion("GYTYPE between", value1, value2, "gytype");
            return (Criteria) this;
        }

        public Criteria andGytypeNotBetween(String value1, String value2) {
            addCriterion("GYTYPE not between", value1, value2, "gytype");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNull() {
            addCriterion("USERNAME is null");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNotNull() {
            addCriterion("USERNAME is not null");
            return (Criteria) this;
        }

        public Criteria andUsernameEqualTo(String value) {
            addCriterion("USERNAME =", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotEqualTo(String value) {
            addCriterion("USERNAME <>", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThan(String value) {
            addCriterion("USERNAME >", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThanOrEqualTo(String value) {
            addCriterion("USERNAME >=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThan(String value) {
            addCriterion("USERNAME <", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThanOrEqualTo(String value) {
            addCriterion("USERNAME <=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLike(String value) {
            addCriterion("USERNAME like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotLike(String value) {
            addCriterion("USERNAME not like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameIn(List<String> values) {
            addCriterion("USERNAME in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotIn(List<String> values) {
            addCriterion("USERNAME not in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameBetween(String value1, String value2) {
            addCriterion("USERNAME between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotBetween(String value1, String value2) {
            addCriterion("USERNAME not between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andRealnameIsNull() {
            addCriterion("REALNAME is null");
            return (Criteria) this;
        }

        public Criteria andRealnameIsNotNull() {
            addCriterion("REALNAME is not null");
            return (Criteria) this;
        }

        public Criteria andRealnameEqualTo(String value) {
            addCriterion("REALNAME =", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameNotEqualTo(String value) {
            addCriterion("REALNAME <>", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameGreaterThan(String value) {
            addCriterion("REALNAME >", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameGreaterThanOrEqualTo(String value) {
            addCriterion("REALNAME >=", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameLessThan(String value) {
            addCriterion("REALNAME <", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameLessThanOrEqualTo(String value) {
            addCriterion("REALNAME <=", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameLike(String value) {
            addCriterion("REALNAME like", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameNotLike(String value) {
            addCriterion("REALNAME not like", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameIn(List<String> values) {
            addCriterion("REALNAME in", values, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameNotIn(List<String> values) {
            addCriterion("REALNAME not in", values, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameBetween(String value1, String value2) {
            addCriterion("REALNAME between", value1, value2, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameNotBetween(String value1, String value2) {
            addCriterion("REALNAME not between", value1, value2, "realname");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("SEX is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("SEX is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(String value) {
            addCriterion("SEX =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(String value) {
            addCriterion("SEX <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(String value) {
            addCriterion("SEX >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(String value) {
            addCriterion("SEX >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(String value) {
            addCriterion("SEX <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(String value) {
            addCriterion("SEX <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLike(String value) {
            addCriterion("SEX like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotLike(String value) {
            addCriterion("SEX not like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<String> values) {
            addCriterion("SEX in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<String> values) {
            addCriterion("SEX not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(String value1, String value2) {
            addCriterion("SEX between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(String value1, String value2) {
            addCriterion("SEX not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("PASSWORD is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("PASSWORD is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("PASSWORD =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("PASSWORD <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("PASSWORD >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("PASSWORD >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("PASSWORD <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("PASSWORD <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("PASSWORD like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("PASSWORD not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("PASSWORD in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("PASSWORD not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("PASSWORD between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("PASSWORD not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andNationIsNull() {
            addCriterion("NATION is null");
            return (Criteria) this;
        }

        public Criteria andNationIsNotNull() {
            addCriterion("NATION is not null");
            return (Criteria) this;
        }

        public Criteria andNationEqualTo(String value) {
            addCriterion("NATION =", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotEqualTo(String value) {
            addCriterion("NATION <>", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThan(String value) {
            addCriterion("NATION >", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThanOrEqualTo(String value) {
            addCriterion("NATION >=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThan(String value) {
            addCriterion("NATION <", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThanOrEqualTo(String value) {
            addCriterion("NATION <=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLike(String value) {
            addCriterion("NATION like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotLike(String value) {
            addCriterion("NATION not like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationIn(List<String> values) {
            addCriterion("NATION in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotIn(List<String> values) {
            addCriterion("NATION not in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationBetween(String value1, String value2) {
            addCriterion("NATION between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotBetween(String value1, String value2) {
            addCriterion("NATION not between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeIsNull() {
            addCriterion("CERTIFICATESTYPE is null");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeIsNotNull() {
            addCriterion("CERTIFICATESTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeEqualTo(String value) {
            addCriterion("CERTIFICATESTYPE =", value, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeNotEqualTo(String value) {
            addCriterion("CERTIFICATESTYPE <>", value, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeGreaterThan(String value) {
            addCriterion("CERTIFICATESTYPE >", value, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeGreaterThanOrEqualTo(String value) {
            addCriterion("CERTIFICATESTYPE >=", value, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeLessThan(String value) {
            addCriterion("CERTIFICATESTYPE <", value, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeLessThanOrEqualTo(String value) {
            addCriterion("CERTIFICATESTYPE <=", value, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeLike(String value) {
            addCriterion("CERTIFICATESTYPE like", value, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeNotLike(String value) {
            addCriterion("CERTIFICATESTYPE not like", value, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeIn(List<String> values) {
            addCriterion("CERTIFICATESTYPE in", values, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeNotIn(List<String> values) {
            addCriterion("CERTIFICATESTYPE not in", values, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeBetween(String value1, String value2) {
            addCriterion("CERTIFICATESTYPE between", value1, value2, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatestypeNotBetween(String value1, String value2) {
            addCriterion("CERTIFICATESTYPE not between", value1, value2, "certificatestype");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoIsNull() {
            addCriterion("CERTIFICATESNO is null");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoIsNotNull() {
            addCriterion("CERTIFICATESNO is not null");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoEqualTo(String value) {
            addCriterion("CERTIFICATESNO =", value, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoNotEqualTo(String value) {
            addCriterion("CERTIFICATESNO <>", value, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoGreaterThan(String value) {
            addCriterion("CERTIFICATESNO >", value, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoGreaterThanOrEqualTo(String value) {
            addCriterion("CERTIFICATESNO >=", value, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoLessThan(String value) {
            addCriterion("CERTIFICATESNO <", value, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoLessThanOrEqualTo(String value) {
            addCriterion("CERTIFICATESNO <=", value, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoLike(String value) {
            addCriterion("CERTIFICATESNO like", value, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoNotLike(String value) {
            addCriterion("CERTIFICATESNO not like", value, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoIn(List<String> values) {
            addCriterion("CERTIFICATESNO in", values, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoNotIn(List<String> values) {
            addCriterion("CERTIFICATESNO not in", values, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoBetween(String value1, String value2) {
            addCriterion("CERTIFICATESNO between", value1, value2, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andCertificatesnoNotBetween(String value1, String value2) {
            addCriterion("CERTIFICATESNO not between", value1, value2, "certificatesno");
            return (Criteria) this;
        }

        public Criteria andBirthdateIsNull() {
            addCriterion("BIRTHDATE is null");
            return (Criteria) this;
        }

        public Criteria andBirthdateIsNotNull() {
            addCriterion("BIRTHDATE is not null");
            return (Criteria) this;
        }

        public Criteria andBirthdateEqualTo(Date value) {
            addCriterionForJDBCDate("BIRTHDATE =", value, "birthdate");
            return (Criteria) this;
        }

        public Criteria andBirthdateNotEqualTo(Date value) {
            addCriterionForJDBCDate("BIRTHDATE <>", value, "birthdate");
            return (Criteria) this;
        }

        public Criteria andBirthdateGreaterThan(Date value) {
            addCriterionForJDBCDate("BIRTHDATE >", value, "birthdate");
            return (Criteria) this;
        }

        public Criteria andBirthdateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("BIRTHDATE >=", value, "birthdate");
            return (Criteria) this;
        }

        public Criteria andBirthdateLessThan(Date value) {
            addCriterionForJDBCDate("BIRTHDATE <", value, "birthdate");
            return (Criteria) this;
        }

        public Criteria andBirthdateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("BIRTHDATE <=", value, "birthdate");
            return (Criteria) this;
        }

        public Criteria andBirthdateIn(List<Date> values) {
            addCriterionForJDBCDate("BIRTHDATE in", values, "birthdate");
            return (Criteria) this;
        }

        public Criteria andBirthdateNotIn(List<Date> values) {
            addCriterionForJDBCDate("BIRTHDATE not in", values, "birthdate");
            return (Criteria) this;
        }

        public Criteria andBirthdateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("BIRTHDATE between", value1, value2, "birthdate");
            return (Criteria) this;
        }

        public Criteria andBirthdateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("BIRTHDATE not between", value1, value2, "birthdate");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoIsNull() {
            addCriterion("CERTIFICATESPHOTO is null");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoIsNotNull() {
            addCriterion("CERTIFICATESPHOTO is not null");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoEqualTo(String value) {
            addCriterion("CERTIFICATESPHOTO =", value, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoNotEqualTo(String value) {
            addCriterion("CERTIFICATESPHOTO <>", value, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoGreaterThan(String value) {
            addCriterion("CERTIFICATESPHOTO >", value, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoGreaterThanOrEqualTo(String value) {
            addCriterion("CERTIFICATESPHOTO >=", value, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoLessThan(String value) {
            addCriterion("CERTIFICATESPHOTO <", value, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoLessThanOrEqualTo(String value) {
            addCriterion("CERTIFICATESPHOTO <=", value, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoLike(String value) {
            addCriterion("CERTIFICATESPHOTO like", value, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoNotLike(String value) {
            addCriterion("CERTIFICATESPHOTO not like", value, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoIn(List<String> values) {
            addCriterion("CERTIFICATESPHOTO in", values, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoNotIn(List<String> values) {
            addCriterion("CERTIFICATESPHOTO not in", values, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoBetween(String value1, String value2) {
            addCriterion("CERTIFICATESPHOTO between", value1, value2, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andCertificatesphotoNotBetween(String value1, String value2) {
            addCriterion("CERTIFICATESPHOTO not between", value1, value2, "certificatesphoto");
            return (Criteria) this;
        }

        public Criteria andPoliticsIsNull() {
            addCriterion("POLITICS is null");
            return (Criteria) this;
        }

        public Criteria andPoliticsIsNotNull() {
            addCriterion("POLITICS is not null");
            return (Criteria) this;
        }

        public Criteria andPoliticsEqualTo(String value) {
            addCriterion("POLITICS =", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotEqualTo(String value) {
            addCriterion("POLITICS <>", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsGreaterThan(String value) {
            addCriterion("POLITICS >", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsGreaterThanOrEqualTo(String value) {
            addCriterion("POLITICS >=", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsLessThan(String value) {
            addCriterion("POLITICS <", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsLessThanOrEqualTo(String value) {
            addCriterion("POLITICS <=", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsLike(String value) {
            addCriterion("POLITICS like", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotLike(String value) {
            addCriterion("POLITICS not like", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsIn(List<String> values) {
            addCriterion("POLITICS in", values, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotIn(List<String> values) {
            addCriterion("POLITICS not in", values, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsBetween(String value1, String value2) {
            addCriterion("POLITICS between", value1, value2, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotBetween(String value1, String value2) {
            addCriterion("POLITICS not between", value1, value2, "politics");
            return (Criteria) this;
        }

        public Criteria andPartybranchIsNull() {
            addCriterion("PARTYBRANCH is null");
            return (Criteria) this;
        }

        public Criteria andPartybranchIsNotNull() {
            addCriterion("PARTYBRANCH is not null");
            return (Criteria) this;
        }

        public Criteria andPartybranchEqualTo(String value) {
            addCriterion("PARTYBRANCH =", value, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchNotEqualTo(String value) {
            addCriterion("PARTYBRANCH <>", value, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchGreaterThan(String value) {
            addCriterion("PARTYBRANCH >", value, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchGreaterThanOrEqualTo(String value) {
            addCriterion("PARTYBRANCH >=", value, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchLessThan(String value) {
            addCriterion("PARTYBRANCH <", value, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchLessThanOrEqualTo(String value) {
            addCriterion("PARTYBRANCH <=", value, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchLike(String value) {
            addCriterion("PARTYBRANCH like", value, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchNotLike(String value) {
            addCriterion("PARTYBRANCH not like", value, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchIn(List<String> values) {
            addCriterion("PARTYBRANCH in", values, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchNotIn(List<String> values) {
            addCriterion("PARTYBRANCH not in", values, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchBetween(String value1, String value2) {
            addCriterion("PARTYBRANCH between", value1, value2, "partybranch");
            return (Criteria) this;
        }

        public Criteria andPartybranchNotBetween(String value1, String value2) {
            addCriterion("PARTYBRANCH not between", value1, value2, "partybranch");
            return (Criteria) this;
        }

        public Criteria andUnitIsNull() {
            addCriterion("UNIT is null");
            return (Criteria) this;
        }

        public Criteria andUnitIsNotNull() {
            addCriterion("UNIT is not null");
            return (Criteria) this;
        }

        public Criteria andUnitEqualTo(String value) {
            addCriterion("UNIT =", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotEqualTo(String value) {
            addCriterion("UNIT <>", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThan(String value) {
            addCriterion("UNIT >", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThanOrEqualTo(String value) {
            addCriterion("UNIT >=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThan(String value) {
            addCriterion("UNIT <", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThanOrEqualTo(String value) {
            addCriterion("UNIT <=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLike(String value) {
            addCriterion("UNIT like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotLike(String value) {
            addCriterion("UNIT not like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitIn(List<String> values) {
            addCriterion("UNIT in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotIn(List<String> values) {
            addCriterion("UNIT not in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitBetween(String value1, String value2) {
            addCriterion("UNIT between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotBetween(String value1, String value2) {
            addCriterion("UNIT not between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andAreaIsNull() {
            addCriterion("AREA is null");
            return (Criteria) this;
        }

        public Criteria andAreaIsNotNull() {
            addCriterion("AREA is not null");
            return (Criteria) this;
        }

        public Criteria andAreaEqualTo(String value) {
            addCriterion("AREA =", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotEqualTo(String value) {
            addCriterion("AREA <>", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaGreaterThan(String value) {
            addCriterion("AREA >", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaGreaterThanOrEqualTo(String value) {
            addCriterion("AREA >=", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLessThan(String value) {
            addCriterion("AREA <", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLessThanOrEqualTo(String value) {
            addCriterion("AREA <=", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLike(String value) {
            addCriterion("AREA like", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotLike(String value) {
            addCriterion("AREA not like", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaIn(List<String> values) {
            addCriterion("AREA in", values, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotIn(List<String> values) {
            addCriterion("AREA not in", values, "area");
            return (Criteria) this;
        }

        public Criteria andAreaBetween(String value1, String value2) {
            addCriterion("AREA between", value1, value2, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotBetween(String value1, String value2) {
            addCriterion("AREA not between", value1, value2, "area");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("MOBILE is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("MOBILE is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("MOBILE =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("MOBILE <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("MOBILE >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("MOBILE <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("MOBILE <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("MOBILE like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("MOBILE not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("MOBILE in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("MOBILE not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("MOBILE between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("MOBILE not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneIsNull() {
            addCriterion("URGENTPHONE is null");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneIsNotNull() {
            addCriterion("URGENTPHONE is not null");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneEqualTo(String value) {
            addCriterion("URGENTPHONE =", value, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneNotEqualTo(String value) {
            addCriterion("URGENTPHONE <>", value, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneGreaterThan(String value) {
            addCriterion("URGENTPHONE >", value, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneGreaterThanOrEqualTo(String value) {
            addCriterion("URGENTPHONE >=", value, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneLessThan(String value) {
            addCriterion("URGENTPHONE <", value, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneLessThanOrEqualTo(String value) {
            addCriterion("URGENTPHONE <=", value, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneLike(String value) {
            addCriterion("URGENTPHONE like", value, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneNotLike(String value) {
            addCriterion("URGENTPHONE not like", value, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneIn(List<String> values) {
            addCriterion("URGENTPHONE in", values, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneNotIn(List<String> values) {
            addCriterion("URGENTPHONE not in", values, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneBetween(String value1, String value2) {
            addCriterion("URGENTPHONE between", value1, value2, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andUrgentphoneNotBetween(String value1, String value2) {
            addCriterion("URGENTPHONE not between", value1, value2, "urgentphone");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeIsNull() {
            addCriterion("PROFESSIONTYPE is null");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeIsNotNull() {
            addCriterion("PROFESSIONTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeEqualTo(String value) {
            addCriterion("PROFESSIONTYPE =", value, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeNotEqualTo(String value) {
            addCriterion("PROFESSIONTYPE <>", value, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeGreaterThan(String value) {
            addCriterion("PROFESSIONTYPE >", value, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeGreaterThanOrEqualTo(String value) {
            addCriterion("PROFESSIONTYPE >=", value, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeLessThan(String value) {
            addCriterion("PROFESSIONTYPE <", value, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeLessThanOrEqualTo(String value) {
            addCriterion("PROFESSIONTYPE <=", value, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeLike(String value) {
            addCriterion("PROFESSIONTYPE like", value, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeNotLike(String value) {
            addCriterion("PROFESSIONTYPE not like", value, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeIn(List<String> values) {
            addCriterion("PROFESSIONTYPE in", values, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeNotIn(List<String> values) {
            addCriterion("PROFESSIONTYPE not in", values, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeBetween(String value1, String value2) {
            addCriterion("PROFESSIONTYPE between", value1, value2, "professiontype");
            return (Criteria) this;
        }

        public Criteria andProfessiontypeNotBetween(String value1, String value2) {
            addCriterion("PROFESSIONTYPE not between", value1, value2, "professiontype");
            return (Criteria) this;
        }

        public Criteria andAddresscodeIsNull() {
            addCriterion("ADDRESSCODE is null");
            return (Criteria) this;
        }

        public Criteria andAddresscodeIsNotNull() {
            addCriterion("ADDRESSCODE is not null");
            return (Criteria) this;
        }

        public Criteria andAddresscodeEqualTo(String value) {
            addCriterion("ADDRESSCODE =", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeNotEqualTo(String value) {
            addCriterion("ADDRESSCODE <>", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeGreaterThan(String value) {
            addCriterion("ADDRESSCODE >", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESSCODE >=", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeLessThan(String value) {
            addCriterion("ADDRESSCODE <", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeLessThanOrEqualTo(String value) {
            addCriterion("ADDRESSCODE <=", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeLike(String value) {
            addCriterion("ADDRESSCODE like", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeNotLike(String value) {
            addCriterion("ADDRESSCODE not like", value, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeIn(List<String> values) {
            addCriterion("ADDRESSCODE in", values, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeNotIn(List<String> values) {
            addCriterion("ADDRESSCODE not in", values, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeBetween(String value1, String value2) {
            addCriterion("ADDRESSCODE between", value1, value2, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddresscodeNotBetween(String value1, String value2) {
            addCriterion("ADDRESSCODE not between", value1, value2, "addresscode");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNull() {
            addCriterion("POSTCODE is null");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNotNull() {
            addCriterion("POSTCODE is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodeEqualTo(String value) {
            addCriterion("POSTCODE =", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotEqualTo(String value) {
            addCriterion("POSTCODE <>", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThan(String value) {
            addCriterion("POSTCODE >", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("POSTCODE >=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThan(String value) {
            addCriterion("POSTCODE <", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThanOrEqualTo(String value) {
            addCriterion("POSTCODE <=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLike(String value) {
            addCriterion("POSTCODE like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotLike(String value) {
            addCriterion("POSTCODE not like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeIn(List<String> values) {
            addCriterion("POSTCODE in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotIn(List<String> values) {
            addCriterion("POSTCODE not in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeBetween(String value1, String value2) {
            addCriterion("POSTCODE between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotBetween(String value1, String value2) {
            addCriterion("POSTCODE not between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andEducationIsNull() {
            addCriterion("EDUCATION is null");
            return (Criteria) this;
        }

        public Criteria andEducationIsNotNull() {
            addCriterion("EDUCATION is not null");
            return (Criteria) this;
        }

        public Criteria andEducationEqualTo(String value) {
            addCriterion("EDUCATION =", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotEqualTo(String value) {
            addCriterion("EDUCATION <>", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationGreaterThan(String value) {
            addCriterion("EDUCATION >", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationGreaterThanOrEqualTo(String value) {
            addCriterion("EDUCATION >=", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLessThan(String value) {
            addCriterion("EDUCATION <", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLessThanOrEqualTo(String value) {
            addCriterion("EDUCATION <=", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLike(String value) {
            addCriterion("EDUCATION like", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotLike(String value) {
            addCriterion("EDUCATION not like", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationIn(List<String> values) {
            addCriterion("EDUCATION in", values, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotIn(List<String> values) {
            addCriterion("EDUCATION not in", values, "education");
            return (Criteria) this;
        }

        public Criteria andEducationBetween(String value1, String value2) {
            addCriterion("EDUCATION between", value1, value2, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotBetween(String value1, String value2) {
            addCriterion("EDUCATION not between", value1, value2, "education");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolIsNull() {
            addCriterion("GRADUATIONSCHOOL is null");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolIsNotNull() {
            addCriterion("GRADUATIONSCHOOL is not null");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolEqualTo(String value) {
            addCriterion("GRADUATIONSCHOOL =", value, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolNotEqualTo(String value) {
            addCriterion("GRADUATIONSCHOOL <>", value, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolGreaterThan(String value) {
            addCriterion("GRADUATIONSCHOOL >", value, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolGreaterThanOrEqualTo(String value) {
            addCriterion("GRADUATIONSCHOOL >=", value, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolLessThan(String value) {
            addCriterion("GRADUATIONSCHOOL <", value, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolLessThanOrEqualTo(String value) {
            addCriterion("GRADUATIONSCHOOL <=", value, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolLike(String value) {
            addCriterion("GRADUATIONSCHOOL like", value, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolNotLike(String value) {
            addCriterion("GRADUATIONSCHOOL not like", value, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolIn(List<String> values) {
            addCriterion("GRADUATIONSCHOOL in", values, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolNotIn(List<String> values) {
            addCriterion("GRADUATIONSCHOOL not in", values, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolBetween(String value1, String value2) {
            addCriterion("GRADUATIONSCHOOL between", value1, value2, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andGraduationschoolNotBetween(String value1, String value2) {
            addCriterion("GRADUATIONSCHOOL not between", value1, value2, "graduationschool");
            return (Criteria) this;
        }

        public Criteria andWorkunitIsNull() {
            addCriterion("WORKUNIT is null");
            return (Criteria) this;
        }

        public Criteria andWorkunitIsNotNull() {
            addCriterion("WORKUNIT is not null");
            return (Criteria) this;
        }

        public Criteria andWorkunitEqualTo(String value) {
            addCriterion("WORKUNIT =", value, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitNotEqualTo(String value) {
            addCriterion("WORKUNIT <>", value, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitGreaterThan(String value) {
            addCriterion("WORKUNIT >", value, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitGreaterThanOrEqualTo(String value) {
            addCriterion("WORKUNIT >=", value, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitLessThan(String value) {
            addCriterion("WORKUNIT <", value, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitLessThanOrEqualTo(String value) {
            addCriterion("WORKUNIT <=", value, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitLike(String value) {
            addCriterion("WORKUNIT like", value, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitNotLike(String value) {
            addCriterion("WORKUNIT not like", value, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitIn(List<String> values) {
            addCriterion("WORKUNIT in", values, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitNotIn(List<String> values) {
            addCriterion("WORKUNIT not in", values, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitBetween(String value1, String value2) {
            addCriterion("WORKUNIT between", value1, value2, "workunit");
            return (Criteria) this;
        }

        public Criteria andWorkunitNotBetween(String value1, String value2) {
            addCriterion("WORKUNIT not between", value1, value2, "workunit");
            return (Criteria) this;
        }

        public Criteria andEmailaddressIsNull() {
            addCriterion("EMAILADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andEmailaddressIsNotNull() {
            addCriterion("EMAILADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andEmailaddressEqualTo(String value) {
            addCriterion("EMAILADDRESS =", value, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressNotEqualTo(String value) {
            addCriterion("EMAILADDRESS <>", value, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressGreaterThan(String value) {
            addCriterion("EMAILADDRESS >", value, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressGreaterThanOrEqualTo(String value) {
            addCriterion("EMAILADDRESS >=", value, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressLessThan(String value) {
            addCriterion("EMAILADDRESS <", value, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressLessThanOrEqualTo(String value) {
            addCriterion("EMAILADDRESS <=", value, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressLike(String value) {
            addCriterion("EMAILADDRESS like", value, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressNotLike(String value) {
            addCriterion("EMAILADDRESS not like", value, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressIn(List<String> values) {
            addCriterion("EMAILADDRESS in", values, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressNotIn(List<String> values) {
            addCriterion("EMAILADDRESS not in", values, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressBetween(String value1, String value2) {
            addCriterion("EMAILADDRESS between", value1, value2, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andEmailaddressNotBetween(String value1, String value2) {
            addCriterion("EMAILADDRESS not between", value1, value2, "emailaddress");
            return (Criteria) this;
        }

        public Criteria andQqIsNull() {
            addCriterion("QQ is null");
            return (Criteria) this;
        }

        public Criteria andQqIsNotNull() {
            addCriterion("QQ is not null");
            return (Criteria) this;
        }

        public Criteria andQqEqualTo(String value) {
            addCriterion("QQ =", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotEqualTo(String value) {
            addCriterion("QQ <>", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqGreaterThan(String value) {
            addCriterion("QQ >", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqGreaterThanOrEqualTo(String value) {
            addCriterion("QQ >=", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLessThan(String value) {
            addCriterion("QQ <", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLessThanOrEqualTo(String value) {
            addCriterion("QQ <=", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLike(String value) {
            addCriterion("QQ like", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotLike(String value) {
            addCriterion("QQ not like", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqIn(List<String> values) {
            addCriterion("QQ in", values, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotIn(List<String> values) {
            addCriterion("QQ not in", values, "qq");
            return (Criteria) this;
        }

        public Criteria andQqBetween(String value1, String value2) {
            addCriterion("QQ between", value1, value2, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotBetween(String value1, String value2) {
            addCriterion("QQ not between", value1, value2, "qq");
            return (Criteria) this;
        }

        public Criteria andWeixinIsNull() {
            addCriterion("WEIXIN is null");
            return (Criteria) this;
        }

        public Criteria andWeixinIsNotNull() {
            addCriterion("WEIXIN is not null");
            return (Criteria) this;
        }

        public Criteria andWeixinEqualTo(String value) {
            addCriterion("WEIXIN =", value, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinNotEqualTo(String value) {
            addCriterion("WEIXIN <>", value, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinGreaterThan(String value) {
            addCriterion("WEIXIN >", value, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinGreaterThanOrEqualTo(String value) {
            addCriterion("WEIXIN >=", value, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinLessThan(String value) {
            addCriterion("WEIXIN <", value, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinLessThanOrEqualTo(String value) {
            addCriterion("WEIXIN <=", value, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinLike(String value) {
            addCriterion("WEIXIN like", value, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinNotLike(String value) {
            addCriterion("WEIXIN not like", value, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinIn(List<String> values) {
            addCriterion("WEIXIN in", values, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinNotIn(List<String> values) {
            addCriterion("WEIXIN not in", values, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinBetween(String value1, String value2) {
            addCriterion("WEIXIN between", value1, value2, "weixin");
            return (Criteria) this;
        }

        public Criteria andWeixinNotBetween(String value1, String value2) {
            addCriterion("WEIXIN not between", value1, value2, "weixin");
            return (Criteria) this;
        }

        public Criteria andCreatetmIsNull() {
            addCriterion("CREATETM is null");
            return (Criteria) this;
        }

        public Criteria andCreatetmIsNotNull() {
            addCriterion("CREATETM is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetmEqualTo(Date value) {
            addCriterionForJDBCDate("CREATETM =", value, "createtm");
            return (Criteria) this;
        }

        public Criteria andCreatetmNotEqualTo(Date value) {
            addCriterionForJDBCDate("CREATETM <>", value, "createtm");
            return (Criteria) this;
        }

        public Criteria andCreatetmGreaterThan(Date value) {
            addCriterionForJDBCDate("CREATETM >", value, "createtm");
            return (Criteria) this;
        }

        public Criteria andCreatetmGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CREATETM >=", value, "createtm");
            return (Criteria) this;
        }

        public Criteria andCreatetmLessThan(Date value) {
            addCriterionForJDBCDate("CREATETM <", value, "createtm");
            return (Criteria) this;
        }

        public Criteria andCreatetmLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CREATETM <=", value, "createtm");
            return (Criteria) this;
        }

        public Criteria andCreatetmIn(List<Date> values) {
            addCriterionForJDBCDate("CREATETM in", values, "createtm");
            return (Criteria) this;
        }

        public Criteria andCreatetmNotIn(List<Date> values) {
            addCriterionForJDBCDate("CREATETM not in", values, "createtm");
            return (Criteria) this;
        }

        public Criteria andCreatetmBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CREATETM between", value1, value2, "createtm");
            return (Criteria) this;
        }

        public Criteria andCreatetmNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CREATETM not between", value1, value2, "createtm");
            return (Criteria) this;
        }

        public Criteria andUpdaterIsNull() {
            addCriterion("UPDATER is null");
            return (Criteria) this;
        }

        public Criteria andUpdaterIsNotNull() {
            addCriterion("UPDATER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdaterEqualTo(BigDecimal value) {
            addCriterion("UPDATER =", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterNotEqualTo(BigDecimal value) {
            addCriterion("UPDATER <>", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterGreaterThan(BigDecimal value) {
            addCriterion("UPDATER >", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("UPDATER >=", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterLessThan(BigDecimal value) {
            addCriterion("UPDATER <", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterLessThanOrEqualTo(BigDecimal value) {
            addCriterion("UPDATER <=", value, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterIn(List<BigDecimal> values) {
            addCriterion("UPDATER in", values, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterNotIn(List<BigDecimal> values) {
            addCriterion("UPDATER not in", values, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UPDATER between", value1, value2, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdaterNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UPDATER not between", value1, value2, "updater");
            return (Criteria) this;
        }

        public Criteria andUpdatenameIsNull() {
            addCriterion("UPDATENAME is null");
            return (Criteria) this;
        }

        public Criteria andUpdatenameIsNotNull() {
            addCriterion("UPDATENAME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatenameEqualTo(String value) {
            addCriterion("UPDATENAME =", value, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameNotEqualTo(String value) {
            addCriterion("UPDATENAME <>", value, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameGreaterThan(String value) {
            addCriterion("UPDATENAME >", value, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATENAME >=", value, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameLessThan(String value) {
            addCriterion("UPDATENAME <", value, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameLessThanOrEqualTo(String value) {
            addCriterion("UPDATENAME <=", value, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameLike(String value) {
            addCriterion("UPDATENAME like", value, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameNotLike(String value) {
            addCriterion("UPDATENAME not like", value, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameIn(List<String> values) {
            addCriterion("UPDATENAME in", values, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameNotIn(List<String> values) {
            addCriterion("UPDATENAME not in", values, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameBetween(String value1, String value2) {
            addCriterion("UPDATENAME between", value1, value2, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatenameNotBetween(String value1, String value2) {
            addCriterion("UPDATENAME not between", value1, value2, "updatename");
            return (Criteria) this;
        }

        public Criteria andUpdatetmIsNull() {
            addCriterion("UPDATETM is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetmIsNotNull() {
            addCriterion("UPDATETM is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetmEqualTo(Date value) {
            addCriterionForJDBCDate("UPDATETM =", value, "updatetm");
            return (Criteria) this;
        }

        public Criteria andUpdatetmNotEqualTo(Date value) {
            addCriterionForJDBCDate("UPDATETM <>", value, "updatetm");
            return (Criteria) this;
        }

        public Criteria andUpdatetmGreaterThan(Date value) {
            addCriterionForJDBCDate("UPDATETM >", value, "updatetm");
            return (Criteria) this;
        }

        public Criteria andUpdatetmGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("UPDATETM >=", value, "updatetm");
            return (Criteria) this;
        }

        public Criteria andUpdatetmLessThan(Date value) {
            addCriterionForJDBCDate("UPDATETM <", value, "updatetm");
            return (Criteria) this;
        }

        public Criteria andUpdatetmLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("UPDATETM <=", value, "updatetm");
            return (Criteria) this;
        }

        public Criteria andUpdatetmIn(List<Date> values) {
            addCriterionForJDBCDate("UPDATETM in", values, "updatetm");
            return (Criteria) this;
        }

        public Criteria andUpdatetmNotIn(List<Date> values) {
            addCriterionForJDBCDate("UPDATETM not in", values, "updatetm");
            return (Criteria) this;
        }

        public Criteria andUpdatetmBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("UPDATETM between", value1, value2, "updatetm");
            return (Criteria) this;
        }

        public Criteria andUpdatetmNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("UPDATETM not between", value1, value2, "updatetm");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("STATE is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLike(String value) {
            addCriterion("STATE like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotLike(String value) {
            addCriterion("STATE not like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<String> values) {
            addCriterion("STATE in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andIsdelIsNull() {
            addCriterion("ISDEL is null");
            return (Criteria) this;
        }

        public Criteria andIsdelIsNotNull() {
            addCriterion("ISDEL is not null");
            return (Criteria) this;
        }

        public Criteria andIsdelEqualTo(BigDecimal value) {
            addCriterion("ISDEL =", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelNotEqualTo(BigDecimal value) {
            addCriterion("ISDEL <>", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelGreaterThan(BigDecimal value) {
            addCriterion("ISDEL >", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ISDEL >=", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelLessThan(BigDecimal value) {
            addCriterion("ISDEL <", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ISDEL <=", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelIn(List<BigDecimal> values) {
            addCriterion("ISDEL in", values, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelNotIn(List<BigDecimal> values) {
            addCriterion("ISDEL not in", values, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ISDEL between", value1, value2, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ISDEL not between", value1, value2, "isdel");
            return (Criteria) this;
        }

        public Criteria andYgcardnoIsNull() {
            addCriterion("YGCARDNO is null");
            return (Criteria) this;
        }

        public Criteria andYgcardnoIsNotNull() {
            addCriterion("YGCARDNO is not null");
            return (Criteria) this;
        }

        public Criteria andYgcardnoEqualTo(String value) {
            addCriterion("YGCARDNO =", value, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoNotEqualTo(String value) {
            addCriterion("YGCARDNO <>", value, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoGreaterThan(String value) {
            addCriterion("YGCARDNO >", value, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoGreaterThanOrEqualTo(String value) {
            addCriterion("YGCARDNO >=", value, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoLessThan(String value) {
            addCriterion("YGCARDNO <", value, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoLessThanOrEqualTo(String value) {
            addCriterion("YGCARDNO <=", value, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoLike(String value) {
            addCriterion("YGCARDNO like", value, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoNotLike(String value) {
            addCriterion("YGCARDNO not like", value, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoIn(List<String> values) {
            addCriterion("YGCARDNO in", values, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoNotIn(List<String> values) {
            addCriterion("YGCARDNO not in", values, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoBetween(String value1, String value2) {
            addCriterion("YGCARDNO between", value1, value2, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andYgcardnoNotBetween(String value1, String value2) {
            addCriterion("YGCARDNO not between", value1, value2, "ygcardno");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonIsNull() {
            addCriterion("NOTPASSREASON is null");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonIsNotNull() {
            addCriterion("NOTPASSREASON is not null");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonEqualTo(String value) {
            addCriterion("NOTPASSREASON =", value, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonNotEqualTo(String value) {
            addCriterion("NOTPASSREASON <>", value, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonGreaterThan(String value) {
            addCriterion("NOTPASSREASON >", value, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonGreaterThanOrEqualTo(String value) {
            addCriterion("NOTPASSREASON >=", value, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonLessThan(String value) {
            addCriterion("NOTPASSREASON <", value, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonLessThanOrEqualTo(String value) {
            addCriterion("NOTPASSREASON <=", value, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonLike(String value) {
            addCriterion("NOTPASSREASON like", value, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonNotLike(String value) {
            addCriterion("NOTPASSREASON not like", value, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonIn(List<String> values) {
            addCriterion("NOTPASSREASON in", values, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonNotIn(List<String> values) {
            addCriterion("NOTPASSREASON not in", values, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonBetween(String value1, String value2) {
            addCriterion("NOTPASSREASON between", value1, value2, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andNotpassreasonNotBetween(String value1, String value2) {
            addCriterion("NOTPASSREASON not between", value1, value2, "notpassreason");
            return (Criteria) this;
        }

        public Criteria andIstrainIsNull() {
            addCriterion("ISTRAIN is null");
            return (Criteria) this;
        }

        public Criteria andIstrainIsNotNull() {
            addCriterion("ISTRAIN is not null");
            return (Criteria) this;
        }

        public Criteria andIstrainEqualTo(String value) {
            addCriterion("ISTRAIN =", value, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainNotEqualTo(String value) {
            addCriterion("ISTRAIN <>", value, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainGreaterThan(String value) {
            addCriterion("ISTRAIN >", value, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainGreaterThanOrEqualTo(String value) {
            addCriterion("ISTRAIN >=", value, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainLessThan(String value) {
            addCriterion("ISTRAIN <", value, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainLessThanOrEqualTo(String value) {
            addCriterion("ISTRAIN <=", value, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainLike(String value) {
            addCriterion("ISTRAIN like", value, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainNotLike(String value) {
            addCriterion("ISTRAIN not like", value, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainIn(List<String> values) {
            addCriterion("ISTRAIN in", values, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainNotIn(List<String> values) {
            addCriterion("ISTRAIN not in", values, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainBetween(String value1, String value2) {
            addCriterion("ISTRAIN between", value1, value2, "istrain");
            return (Criteria) this;
        }

        public Criteria andIstrainNotBetween(String value1, String value2) {
            addCriterion("ISTRAIN not between", value1, value2, "istrain");
            return (Criteria) this;
        }

        public Criteria andIsserviceIsNull() {
            addCriterion("ISSERVICE is null");
            return (Criteria) this;
        }

        public Criteria andIsserviceIsNotNull() {
            addCriterion("ISSERVICE is not null");
            return (Criteria) this;
        }

        public Criteria andIsserviceEqualTo(String value) {
            addCriterion("ISSERVICE =", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotEqualTo(String value) {
            addCriterion("ISSERVICE <>", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceGreaterThan(String value) {
            addCriterion("ISSERVICE >", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceGreaterThanOrEqualTo(String value) {
            addCriterion("ISSERVICE >=", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceLessThan(String value) {
            addCriterion("ISSERVICE <", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceLessThanOrEqualTo(String value) {
            addCriterion("ISSERVICE <=", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceLike(String value) {
            addCriterion("ISSERVICE like", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotLike(String value) {
            addCriterion("ISSERVICE not like", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceIn(List<String> values) {
            addCriterion("ISSERVICE in", values, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotIn(List<String> values) {
            addCriterion("ISSERVICE not in", values, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceBetween(String value1, String value2) {
            addCriterion("ISSERVICE between", value1, value2, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotBetween(String value1, String value2) {
            addCriterion("ISSERVICE not between", value1, value2, "isservice");
            return (Criteria) this;
        }

        public Criteria andIscardIsNull() {
            addCriterion("ISCARD is null");
            return (Criteria) this;
        }

        public Criteria andIscardIsNotNull() {
            addCriterion("ISCARD is not null");
            return (Criteria) this;
        }

        public Criteria andIscardEqualTo(String value) {
            addCriterion("ISCARD =", value, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardNotEqualTo(String value) {
            addCriterion("ISCARD <>", value, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardGreaterThan(String value) {
            addCriterion("ISCARD >", value, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardGreaterThanOrEqualTo(String value) {
            addCriterion("ISCARD >=", value, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardLessThan(String value) {
            addCriterion("ISCARD <", value, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardLessThanOrEqualTo(String value) {
            addCriterion("ISCARD <=", value, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardLike(String value) {
            addCriterion("ISCARD like", value, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardNotLike(String value) {
            addCriterion("ISCARD not like", value, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardIn(List<String> values) {
            addCriterion("ISCARD in", values, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardNotIn(List<String> values) {
            addCriterion("ISCARD not in", values, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardBetween(String value1, String value2) {
            addCriterion("ISCARD between", value1, value2, "iscard");
            return (Criteria) this;
        }

        public Criteria andIscardNotBetween(String value1, String value2) {
            addCriterion("ISCARD not between", value1, value2, "iscard");
            return (Criteria) this;
        }

        public Criteria andDeptidIsNull() {
            addCriterion("DEPTID is null");
            return (Criteria) this;
        }

        public Criteria andDeptidIsNotNull() {
            addCriterion("DEPTID is not null");
            return (Criteria) this;
        }

        public Criteria andDeptidEqualTo(BigDecimal value) {
            addCriterion("DEPTID =", value, "deptid");
            return (Criteria) this;
        }

        public Criteria andDeptidNotEqualTo(BigDecimal value) {
            addCriterion("DEPTID <>", value, "deptid");
            return (Criteria) this;
        }

        public Criteria andDeptidGreaterThan(BigDecimal value) {
            addCriterion("DEPTID >", value, "deptid");
            return (Criteria) this;
        }

        public Criteria andDeptidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DEPTID >=", value, "deptid");
            return (Criteria) this;
        }

        public Criteria andDeptidLessThan(BigDecimal value) {
            addCriterion("DEPTID <", value, "deptid");
            return (Criteria) this;
        }

        public Criteria andDeptidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DEPTID <=", value, "deptid");
            return (Criteria) this;
        }

        public Criteria andDeptidIn(List<BigDecimal> values) {
            addCriterion("DEPTID in", values, "deptid");
            return (Criteria) this;
        }

        public Criteria andDeptidNotIn(List<BigDecimal> values) {
            addCriterion("DEPTID not in", values, "deptid");
            return (Criteria) this;
        }

        public Criteria andDeptidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DEPTID between", value1, value2, "deptid");
            return (Criteria) this;
        }

        public Criteria andDeptidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DEPTID not between", value1, value2, "deptid");
            return (Criteria) this;
        }

        public Criteria andRegtmIsNull() {
            addCriterion("REGTM is null");
            return (Criteria) this;
        }

        public Criteria andRegtmIsNotNull() {
            addCriterion("REGTM is not null");
            return (Criteria) this;
        }

        public Criteria andRegtmEqualTo(Date value) {
            addCriterionForJDBCDate("REGTM =", value, "regtm");
            return (Criteria) this;
        }

        public Criteria andRegtmNotEqualTo(Date value) {
            addCriterionForJDBCDate("REGTM <>", value, "regtm");
            return (Criteria) this;
        }

        public Criteria andRegtmGreaterThan(Date value) {
            addCriterionForJDBCDate("REGTM >", value, "regtm");
            return (Criteria) this;
        }

        public Criteria andRegtmGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("REGTM >=", value, "regtm");
            return (Criteria) this;
        }

        public Criteria andRegtmLessThan(Date value) {
            addCriterionForJDBCDate("REGTM <", value, "regtm");
            return (Criteria) this;
        }

        public Criteria andRegtmLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("REGTM <=", value, "regtm");
            return (Criteria) this;
        }

        public Criteria andRegtmIn(List<Date> values) {
            addCriterionForJDBCDate("REGTM in", values, "regtm");
            return (Criteria) this;
        }

        public Criteria andRegtmNotIn(List<Date> values) {
            addCriterionForJDBCDate("REGTM not in", values, "regtm");
            return (Criteria) this;
        }

        public Criteria andRegtmBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("REGTM between", value1, value2, "regtm");
            return (Criteria) this;
        }

        public Criteria andRegtmNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("REGTM not between", value1, value2, "regtm");
            return (Criteria) this;
        }

        public Criteria andIslockIsNull() {
            addCriterion("ISLOCK is null");
            return (Criteria) this;
        }

        public Criteria andIslockIsNotNull() {
            addCriterion("ISLOCK is not null");
            return (Criteria) this;
        }

        public Criteria andIslockEqualTo(String value) {
            addCriterion("ISLOCK =", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockNotEqualTo(String value) {
            addCriterion("ISLOCK <>", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockGreaterThan(String value) {
            addCriterion("ISLOCK >", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockGreaterThanOrEqualTo(String value) {
            addCriterion("ISLOCK >=", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockLessThan(String value) {
            addCriterion("ISLOCK <", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockLessThanOrEqualTo(String value) {
            addCriterion("ISLOCK <=", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockLike(String value) {
            addCriterion("ISLOCK like", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockNotLike(String value) {
            addCriterion("ISLOCK not like", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockIn(List<String> values) {
            addCriterion("ISLOCK in", values, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockNotIn(List<String> values) {
            addCriterion("ISLOCK not in", values, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockBetween(String value1, String value2) {
            addCriterion("ISLOCK between", value1, value2, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockNotBetween(String value1, String value2) {
            addCriterion("ISLOCK not between", value1, value2, "islock");
            return (Criteria) this;
        }

        public Criteria andOfficialtmIsNull() {
            addCriterion("OFFICIALTM is null");
            return (Criteria) this;
        }

        public Criteria andOfficialtmIsNotNull() {
            addCriterion("OFFICIALTM is not null");
            return (Criteria) this;
        }

        public Criteria andOfficialtmEqualTo(Date value) {
            addCriterionForJDBCDate("OFFICIALTM =", value, "officialtm");
            return (Criteria) this;
        }

        public Criteria andOfficialtmNotEqualTo(Date value) {
            addCriterionForJDBCDate("OFFICIALTM <>", value, "officialtm");
            return (Criteria) this;
        }

        public Criteria andOfficialtmGreaterThan(Date value) {
            addCriterionForJDBCDate("OFFICIALTM >", value, "officialtm");
            return (Criteria) this;
        }

        public Criteria andOfficialtmGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("OFFICIALTM >=", value, "officialtm");
            return (Criteria) this;
        }

        public Criteria andOfficialtmLessThan(Date value) {
            addCriterionForJDBCDate("OFFICIALTM <", value, "officialtm");
            return (Criteria) this;
        }

        public Criteria andOfficialtmLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("OFFICIALTM <=", value, "officialtm");
            return (Criteria) this;
        }

        public Criteria andOfficialtmIn(List<Date> values) {
            addCriterionForJDBCDate("OFFICIALTM in", values, "officialtm");
            return (Criteria) this;
        }

        public Criteria andOfficialtmNotIn(List<Date> values) {
            addCriterionForJDBCDate("OFFICIALTM not in", values, "officialtm");
            return (Criteria) this;
        }

        public Criteria andOfficialtmBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("OFFICIALTM between", value1, value2, "officialtm");
            return (Criteria) this;
        }

        public Criteria andOfficialtmNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("OFFICIALTM not between", value1, value2, "officialtm");
            return (Criteria) this;
        }

        public Criteria andIscacheIsNull() {
            addCriterion("ISCACHE is null");
            return (Criteria) this;
        }

        public Criteria andIscacheIsNotNull() {
            addCriterion("ISCACHE is not null");
            return (Criteria) this;
        }

        public Criteria andIscacheEqualTo(String value) {
            addCriterion("ISCACHE =", value, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheNotEqualTo(String value) {
            addCriterion("ISCACHE <>", value, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheGreaterThan(String value) {
            addCriterion("ISCACHE >", value, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheGreaterThanOrEqualTo(String value) {
            addCriterion("ISCACHE >=", value, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheLessThan(String value) {
            addCriterion("ISCACHE <", value, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheLessThanOrEqualTo(String value) {
            addCriterion("ISCACHE <=", value, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheLike(String value) {
            addCriterion("ISCACHE like", value, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheNotLike(String value) {
            addCriterion("ISCACHE not like", value, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheIn(List<String> values) {
            addCriterion("ISCACHE in", values, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheNotIn(List<String> values) {
            addCriterion("ISCACHE not in", values, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheBetween(String value1, String value2) {
            addCriterion("ISCACHE between", value1, value2, "iscache");
            return (Criteria) this;
        }

        public Criteria andIscacheNotBetween(String value1, String value2) {
            addCriterion("ISCACHE not between", value1, value2, "iscache");
            return (Criteria) this;
        }

        public Criteria andCachetmIsNull() {
            addCriterion("CACHETM is null");
            return (Criteria) this;
        }

        public Criteria andCachetmIsNotNull() {
            addCriterion("CACHETM is not null");
            return (Criteria) this;
        }

        public Criteria andCachetmEqualTo(Date value) {
            addCriterionForJDBCDate("CACHETM =", value, "cachetm");
            return (Criteria) this;
        }

        public Criteria andCachetmNotEqualTo(Date value) {
            addCriterionForJDBCDate("CACHETM <>", value, "cachetm");
            return (Criteria) this;
        }

        public Criteria andCachetmGreaterThan(Date value) {
            addCriterionForJDBCDate("CACHETM >", value, "cachetm");
            return (Criteria) this;
        }

        public Criteria andCachetmGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CACHETM >=", value, "cachetm");
            return (Criteria) this;
        }

        public Criteria andCachetmLessThan(Date value) {
            addCriterionForJDBCDate("CACHETM <", value, "cachetm");
            return (Criteria) this;
        }

        public Criteria andCachetmLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CACHETM <=", value, "cachetm");
            return (Criteria) this;
        }

        public Criteria andCachetmIn(List<Date> values) {
            addCriterionForJDBCDate("CACHETM in", values, "cachetm");
            return (Criteria) this;
        }

        public Criteria andCachetmNotIn(List<Date> values) {
            addCriterionForJDBCDate("CACHETM not in", values, "cachetm");
            return (Criteria) this;
        }

        public Criteria andCachetmBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CACHETM between", value1, value2, "cachetm");
            return (Criteria) this;
        }

        public Criteria andCachetmNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CACHETM not between", value1, value2, "cachetm");
            return (Criteria) this;
        }

        public Criteria andLocktmIsNull() {
            addCriterion("LOCKTM is null");
            return (Criteria) this;
        }

        public Criteria andLocktmIsNotNull() {
            addCriterion("LOCKTM is not null");
            return (Criteria) this;
        }

        public Criteria andLocktmEqualTo(Date value) {
            addCriterionForJDBCDate("LOCKTM =", value, "locktm");
            return (Criteria) this;
        }

        public Criteria andLocktmNotEqualTo(Date value) {
            addCriterionForJDBCDate("LOCKTM <>", value, "locktm");
            return (Criteria) this;
        }

        public Criteria andLocktmGreaterThan(Date value) {
            addCriterionForJDBCDate("LOCKTM >", value, "locktm");
            return (Criteria) this;
        }

        public Criteria andLocktmGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("LOCKTM >=", value, "locktm");
            return (Criteria) this;
        }

        public Criteria andLocktmLessThan(Date value) {
            addCriterionForJDBCDate("LOCKTM <", value, "locktm");
            return (Criteria) this;
        }

        public Criteria andLocktmLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("LOCKTM <=", value, "locktm");
            return (Criteria) this;
        }

        public Criteria andLocktmIn(List<Date> values) {
            addCriterionForJDBCDate("LOCKTM in", values, "locktm");
            return (Criteria) this;
        }

        public Criteria andLocktmNotIn(List<Date> values) {
            addCriterionForJDBCDate("LOCKTM not in", values, "locktm");
            return (Criteria) this;
        }

        public Criteria andLocktmBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("LOCKTM between", value1, value2, "locktm");
            return (Criteria) this;
        }

        public Criteria andLocktmNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("LOCKTM not between", value1, value2, "locktm");
            return (Criteria) this;
        }

        public Criteria andAvatarIsNull() {
            addCriterion("AVATAR is null");
            return (Criteria) this;
        }

        public Criteria andAvatarIsNotNull() {
            addCriterion("AVATAR is not null");
            return (Criteria) this;
        }

        public Criteria andAvatarEqualTo(String value) {
            addCriterion("AVATAR =", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarNotEqualTo(String value) {
            addCriterion("AVATAR <>", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarGreaterThan(String value) {
            addCriterion("AVATAR >", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarGreaterThanOrEqualTo(String value) {
            addCriterion("AVATAR >=", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarLessThan(String value) {
            addCriterion("AVATAR <", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarLessThanOrEqualTo(String value) {
            addCriterion("AVATAR <=", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarLike(String value) {
            addCriterion("AVATAR like", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarNotLike(String value) {
            addCriterion("AVATAR not like", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarIn(List<String> values) {
            addCriterion("AVATAR in", values, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarNotIn(List<String> values) {
            addCriterion("AVATAR not in", values, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarBetween(String value1, String value2) {
            addCriterion("AVATAR between", value1, value2, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarNotBetween(String value1, String value2) {
            addCriterion("AVATAR not between", value1, value2, "avatar");
            return (Criteria) this;
        }

        public Criteria andIsproveIsNull() {
            addCriterion("ISPROVE is null");
            return (Criteria) this;
        }

        public Criteria andIsproveIsNotNull() {
            addCriterion("ISPROVE is not null");
            return (Criteria) this;
        }

        public Criteria andIsproveEqualTo(String value) {
            addCriterion("ISPROVE =", value, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveNotEqualTo(String value) {
            addCriterion("ISPROVE <>", value, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveGreaterThan(String value) {
            addCriterion("ISPROVE >", value, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveGreaterThanOrEqualTo(String value) {
            addCriterion("ISPROVE >=", value, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveLessThan(String value) {
            addCriterion("ISPROVE <", value, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveLessThanOrEqualTo(String value) {
            addCriterion("ISPROVE <=", value, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveLike(String value) {
            addCriterion("ISPROVE like", value, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveNotLike(String value) {
            addCriterion("ISPROVE not like", value, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveIn(List<String> values) {
            addCriterion("ISPROVE in", values, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveNotIn(List<String> values) {
            addCriterion("ISPROVE not in", values, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveBetween(String value1, String value2) {
            addCriterion("ISPROVE between", value1, value2, "isprove");
            return (Criteria) this;
        }

        public Criteria andIsproveNotBetween(String value1, String value2) {
            addCriterion("ISPROVE not between", value1, value2, "isprove");
            return (Criteria) this;
        }

        public Criteria andServicecountIsNull() {
            addCriterion("SERVICECOUNT is null");
            return (Criteria) this;
        }

        public Criteria andServicecountIsNotNull() {
            addCriterion("SERVICECOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andServicecountEqualTo(BigDecimal value) {
            addCriterion("SERVICECOUNT =", value, "servicecount");
            return (Criteria) this;
        }

        public Criteria andServicecountNotEqualTo(BigDecimal value) {
            addCriterion("SERVICECOUNT <>", value, "servicecount");
            return (Criteria) this;
        }

        public Criteria andServicecountGreaterThan(BigDecimal value) {
            addCriterion("SERVICECOUNT >", value, "servicecount");
            return (Criteria) this;
        }

        public Criteria andServicecountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICECOUNT >=", value, "servicecount");
            return (Criteria) this;
        }

        public Criteria andServicecountLessThan(BigDecimal value) {
            addCriterion("SERVICECOUNT <", value, "servicecount");
            return (Criteria) this;
        }

        public Criteria andServicecountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICECOUNT <=", value, "servicecount");
            return (Criteria) this;
        }

        public Criteria andServicecountIn(List<BigDecimal> values) {
            addCriterion("SERVICECOUNT in", values, "servicecount");
            return (Criteria) this;
        }

        public Criteria andServicecountNotIn(List<BigDecimal> values) {
            addCriterion("SERVICECOUNT not in", values, "servicecount");
            return (Criteria) this;
        }

        public Criteria andServicecountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICECOUNT between", value1, value2, "servicecount");
            return (Criteria) this;
        }

        public Criteria andServicecountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICECOUNT not between", value1, value2, "servicecount");
            return (Criteria) this;
        }

        public Criteria andServicetimeIsNull() {
            addCriterion("SERVICETIME is null");
            return (Criteria) this;
        }

        public Criteria andServicetimeIsNotNull() {
            addCriterion("SERVICETIME is not null");
            return (Criteria) this;
        }

        public Criteria andServicetimeEqualTo(BigDecimal value) {
            addCriterion("SERVICETIME =", value, "servicetime");
            return (Criteria) this;
        }

        public Criteria andServicetimeNotEqualTo(BigDecimal value) {
            addCriterion("SERVICETIME <>", value, "servicetime");
            return (Criteria) this;
        }

        public Criteria andServicetimeGreaterThan(BigDecimal value) {
            addCriterion("SERVICETIME >", value, "servicetime");
            return (Criteria) this;
        }

        public Criteria andServicetimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICETIME >=", value, "servicetime");
            return (Criteria) this;
        }

        public Criteria andServicetimeLessThan(BigDecimal value) {
            addCriterion("SERVICETIME <", value, "servicetime");
            return (Criteria) this;
        }

        public Criteria andServicetimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICETIME <=", value, "servicetime");
            return (Criteria) this;
        }

        public Criteria andServicetimeIn(List<BigDecimal> values) {
            addCriterion("SERVICETIME in", values, "servicetime");
            return (Criteria) this;
        }

        public Criteria andServicetimeNotIn(List<BigDecimal> values) {
            addCriterion("SERVICETIME not in", values, "servicetime");
            return (Criteria) this;
        }

        public Criteria andServicetimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICETIME between", value1, value2, "servicetime");
            return (Criteria) this;
        }

        public Criteria andServicetimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICETIME not between", value1, value2, "servicetime");
            return (Criteria) this;
        }

        public Criteria andTraincountIsNull() {
            addCriterion("TRAINCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andTraincountIsNotNull() {
            addCriterion("TRAINCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andTraincountEqualTo(BigDecimal value) {
            addCriterion("TRAINCOUNT =", value, "traincount");
            return (Criteria) this;
        }

        public Criteria andTraincountNotEqualTo(BigDecimal value) {
            addCriterion("TRAINCOUNT <>", value, "traincount");
            return (Criteria) this;
        }

        public Criteria andTraincountGreaterThan(BigDecimal value) {
            addCriterion("TRAINCOUNT >", value, "traincount");
            return (Criteria) this;
        }

        public Criteria andTraincountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TRAINCOUNT >=", value, "traincount");
            return (Criteria) this;
        }

        public Criteria andTraincountLessThan(BigDecimal value) {
            addCriterion("TRAINCOUNT <", value, "traincount");
            return (Criteria) this;
        }

        public Criteria andTraincountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TRAINCOUNT <=", value, "traincount");
            return (Criteria) this;
        }

        public Criteria andTraincountIn(List<BigDecimal> values) {
            addCriterion("TRAINCOUNT in", values, "traincount");
            return (Criteria) this;
        }

        public Criteria andTraincountNotIn(List<BigDecimal> values) {
            addCriterion("TRAINCOUNT not in", values, "traincount");
            return (Criteria) this;
        }

        public Criteria andTraincountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TRAINCOUNT between", value1, value2, "traincount");
            return (Criteria) this;
        }

        public Criteria andTraincountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TRAINCOUNT not between", value1, value2, "traincount");
            return (Criteria) this;
        }

        public Criteria andTraintimeIsNull() {
            addCriterion("TRAINTIME is null");
            return (Criteria) this;
        }

        public Criteria andTraintimeIsNotNull() {
            addCriterion("TRAINTIME is not null");
            return (Criteria) this;
        }

        public Criteria andTraintimeEqualTo(BigDecimal value) {
            addCriterion("TRAINTIME =", value, "traintime");
            return (Criteria) this;
        }

        public Criteria andTraintimeNotEqualTo(BigDecimal value) {
            addCriterion("TRAINTIME <>", value, "traintime");
            return (Criteria) this;
        }

        public Criteria andTraintimeGreaterThan(BigDecimal value) {
            addCriterion("TRAINTIME >", value, "traintime");
            return (Criteria) this;
        }

        public Criteria andTraintimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TRAINTIME >=", value, "traintime");
            return (Criteria) this;
        }

        public Criteria andTraintimeLessThan(BigDecimal value) {
            addCriterion("TRAINTIME <", value, "traintime");
            return (Criteria) this;
        }

        public Criteria andTraintimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TRAINTIME <=", value, "traintime");
            return (Criteria) this;
        }

        public Criteria andTraintimeIn(List<BigDecimal> values) {
            addCriterion("TRAINTIME in", values, "traintime");
            return (Criteria) this;
        }

        public Criteria andTraintimeNotIn(List<BigDecimal> values) {
            addCriterion("TRAINTIME not in", values, "traintime");
            return (Criteria) this;
        }

        public Criteria andTraintimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TRAINTIME between", value1, value2, "traintime");
            return (Criteria) this;
        }

        public Criteria andTraintimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TRAINTIME not between", value1, value2, "traintime");
            return (Criteria) this;
        }

        public Criteria andGuardiannameIsNull() {
            addCriterion("GUARDIANNAME is null");
            return (Criteria) this;
        }

        public Criteria andGuardiannameIsNotNull() {
            addCriterion("GUARDIANNAME is not null");
            return (Criteria) this;
        }

        public Criteria andGuardiannameEqualTo(String value) {
            addCriterion("GUARDIANNAME =", value, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameNotEqualTo(String value) {
            addCriterion("GUARDIANNAME <>", value, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameGreaterThan(String value) {
            addCriterion("GUARDIANNAME >", value, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameGreaterThanOrEqualTo(String value) {
            addCriterion("GUARDIANNAME >=", value, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameLessThan(String value) {
            addCriterion("GUARDIANNAME <", value, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameLessThanOrEqualTo(String value) {
            addCriterion("GUARDIANNAME <=", value, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameLike(String value) {
            addCriterion("GUARDIANNAME like", value, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameNotLike(String value) {
            addCriterion("GUARDIANNAME not like", value, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameIn(List<String> values) {
            addCriterion("GUARDIANNAME in", values, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameNotIn(List<String> values) {
            addCriterion("GUARDIANNAME not in", values, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameBetween(String value1, String value2) {
            addCriterion("GUARDIANNAME between", value1, value2, "guardianname");
            return (Criteria) this;
        }

        public Criteria andGuardiannameNotBetween(String value1, String value2) {
            addCriterion("GUARDIANNAME not between", value1, value2, "guardianname");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}